﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
create PROCEDURE [dbo].[proc_Employee_LateCount]
	(
	@datesta datetime,
	@dateend datetime,
	@username varchar(20)
	)
AS
BEGIN
	
	select count(1) as a from Employee_Attendance where UserName=@username  and t_flag in (1,2,3,4) 
	and KouKuanFromDate>=@datesta and KouKuanFromDate<=@dateend
	
END
